Analiza systemu operacyjnego hosta


top

vmstat 5 10

mpstat 2 5

iostat

iostat 2 5





Raport AWR w bazach Oracle


SELECT SNAP_INTERVAL, RETENTION FROM DBA_HIST_WR_CONTROL;

EXECUTE DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS (interval  =>  60, retention =>  14 * 24 * 60);

sql / as sysdba

@?/rdbms/admin/awrrpt.sql





Statspack

sql / as sysdba

@?/rdbms/admin/spcreate.sql

sql PERFSTAT@//localhost:1521/db01


EXEC STATSPACK.snap;

@?/rdbms/admin/spreport.sql

sql / as sysdba

@?/rdbms/admin/spdrop.sql

